﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using BOMS.Utility;
using BOMS.DBUtility;

namespace BOMS.DAL
{
   public class SingleHistory
    {

                public static DataTable getBatOfGroupByLogId(string logId)
                {
            string str = @"select b.*,m.hostname from   S_BatgrpSubLog g,S_BatSubLog b ,m_sublans m 
                    where g.generation=b.generation and g.equipid=b.equipid and g.batterygroup=b.batterygroup and g.logtime=b.logtime and g.equipid=m.mac and g.logid=" + logId;
            DataTable dt = DBUtility.DbHelper.Rt_Table(str);
            return dt;
        }

        
    }
}
